[dbo].[GroupOpportunityType]

Property	Value
Row Count	0
Created	10:31:24 AM Tuesday, March 02, 2010
Last Modified	11:40:03 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:24 AM Tuesday, March 02, 2010

Last Modified

11:40:03 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key PK_GroupOpportunityType: GroupKey\OpportunityTypeKey$	GroupKey	uniqueidentifier	16
$Cluster Primary Key PK_GroupOpportunityType: GroupKey\OpportunityTypeKey$	OpportunityTypeKey	uniqueidentifier	16

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_GroupOpportunityType: GroupKey\OpportunityTypeKey$

GroupKey

uniqueidentifier

$Cluster Primary Key PK_GroupOpportunityType: GroupKey\OpportunityTypeKey$

OpportunityTypeKey

uniqueidentifier

	Name	Columns	Unique
$Cluster Primary Key PK_GroupOpportunityType: GroupKey\OpportunityTypeKey$	PK_GroupOpportunityType	GroupKey, OpportunityTypeKey

Name

Columns

Unique

$Cluster Primary Key PK_GroupOpportunityType: GroupKey\OpportunityTypeKey$

PK_GroupOpportunityType

GroupKey, OpportunityTypeKey

Name	Columns
FK_GroupOpportunityType_GroupMain	GroupKey->[dbo].[GroupMain].[GroupKey]
FK_GroupOpportunityType_OpportunityType	OpportunityTypeKey->[dbo].[OpportunityType].[OpportunityTypeKey]

Name

Columns

FK_GroupOpportunityType_GroupMain

GroupKey->[dbo].[GroupMain].[GroupKey]

FK_GroupOpportunityType_OpportunityType

OpportunityTypeKey->[dbo].[OpportunityType].[OpportunityTypeKey]

SQL Script

CREATE TABLE [dbo].[GroupOpportunityType]
(
[GroupKey] [uniqueidentifier] NOT NULL,
[OpportunityTypeKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GroupOpportunityType] ADD CONSTRAINT [PK_GroupOpportunityType] PRIMARY KEY CLUSTERED ([GroupKey], [OpportunityTypeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupOpportunityType] ADD CONSTRAINT [FK_GroupOpportunityType_GroupMain] FOREIGN KEY ([GroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[GroupOpportunityType] ADD CONSTRAINT [FK_GroupOpportunityType_OpportunityType] FOREIGN KEY ([OpportunityTypeKey]) REFERENCES [dbo].[OpportunityType] ([OpportunityTypeKey])
GO